<?php
// uncomment the following to use a MySQL database
return array(
		'components'=>array(
			'db'=>array(
				'class' => 'CDbConnection',
				'connectionString' => 'mysql:host=127.0.0.1;dbname=webapp',
				'emulatePrepare' => true, //是否记录绑定变量（如果使用prepare方式进行查询，如果记录sql语句，是看不到绑定变量的值的），调试时使用
				'username' => 'root',
				'password' => '123456',
				'charset' => 'utf8',
		        'tablePrefix' => 'wdb_',
		        // 'enabled'=>!YII_DEBUG,       // false禁用db组件
		        'emulatePrepare' => false,
		        'enableParamLogging' => false,   // CDbConnection::getStats() 查看执行了多少个语句,用了多少时间 是否记录SQL语句，调试时使用
		        'enableProfiling' => true,     // 关闭页面上sql记录日志 同时要log routes CProfileLogRoute一起用 CDbConnection::getStats() 查看执行了多少个语句
		        'schemaCachingDuration'=>0,  // 使用db cache表的元数据将被缓存
		        // 'schemaCacheID' => 'dbschemecache',
			    // 'persistent'=>false,
           ),
		   /*'dbche'=>array(
				'class'=>'CDbConnection', //不可少
				'connectionString' => 'mysql:host=127.0.0.1;dbname=webche',
				'emulatePrepare' => true,
				'username' => 'root',
				'password' => '123456',
				'charset' => 'utf8',
				'tablePrefix' => 'wce_',
				// 'enabled'=>!YII_DEBUG,       // false禁用db组件
				'emulatePrepare' => true,
				'enableParamLogging' => false,
				'enableProfiling' => true,
				'schemaCachingDuration'=>0,
		  ),
		  'dbcms'=>array(
		  		'class'=>'CDbConnection', //不可少
		  		'connectionString' => 'mysql:host=127.0.0.1;dbname=webcms',
		  		'emulatePrepare' => true,
		  		'username' => 'root',
		  		'password' => '123456',
		  		'charset' => 'utf8',
		  		'tablePrefix' => 'wce_',
		  		// 'enabled'=>!YII_DEBUG,       // false禁用db组件
		  		'emulatePrepare' => true,
		  		'enableParamLogging' => false,
		  		'enableProfiling' => true,
		  		'schemaCachingDuration'=>0,
		  ),
		  'dbshop'=>array(
		  		'class'=>'CDbConnection', //不可少
		  		'connectionString' => 'mysql:host=127.0.0.1;dbname=webshop',
		  		'emulatePrepare' => true,
		  		'username' => 'root',
		  		'password' => '123456',
		  		'charset' => 'utf8',
		  		'tablePrefix' => 'wce_',
		  		// 'enabled'=>!YII_DEBUG,       // false禁用db组件
		  		'emulatePrepare' => true,
		  		'enableParamLogging' => false,
		  		'enableProfiling' => true,
		  		'schemaCachingDuration'=>0,
		  ),*/
      )
);